This keyword returns the CONNX native type, length, precision, and scale in the description field of the metadata functions that describe the columns. This metadata is available from four different sources:

1. JDBC metadata calls

2. ODBC metadata calls (SQL columns)

3. ADO metadata calls OpenSchema (ADODB.SchemaEnum.adSchemaColumns)

4. CONNX metadata tables (syscnxColumns)

The format of the description field is as follows:

 

NativeType = ### :NativeSize = ##### : NativePrecision = ##### : NativeScale ###

 

Example:

NativeType = 1 :NativeSize = 20 : NativePrecision = 0 : NativeScale 0